﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Crosland.Automotriz.Core;
namespace Crosland.Automotriz.Data.Dao.Linq
{
    public class clsTd_Oficina_VentaDAO
    {

        private AutomotrizEntities ContextoDeObjs = new AutomotrizEntities();


        public IEnumerable<Object> lista() {

            IEnumerable<Object> list = new List<Object>();
            try
            {

                var q = from c in ContextoDeObjs.TD_OFICINA_VENTA
                        orderby c.DES_OFI_VTA ascending
                        select new { 
                        c.ID_OFI_VTA,
                        c.DES_OFI_VTA                        
                        };


                list = q.ToList();
            }
            catch{
            
            }

            return list;
        
        
        }


    }
}
